Example: SQL Expression

The dataset will be modified to contain the fields added from defining additional SQL expressions.

Initial dataset:

Configuration:

Field name: NewField1

Field type: Double

Expression: [Field1]*[Field2]

Field name: NewField2

Field type: Double

Expression: COS([Field2])

Resulting dataset:

Related topics:

• Overview of operation: SQL expressions

• Configuring operation: SQL expressions

• Overview of operations

• Technical comparison of operations

• Overview of icons